SELECT NAME, SIGNATURE, TYPE
FROM USER_IDENTIFIERS
WHERE  USAGE='DECLARATION'
ORDER BY OBJECT_TYPE, USAGE_ID;
